# Query Description
# Type of request:                 Extract data from a table
# Name of the selected table:      sophies
# Description of the table:        Spectra (series truncated to the first observation)
# Object:                          HD105422
# Order by:                        ra,seq
# Description of each column
# $link[objname]: ------ Designation of the object
# $j2000: -------------- J2000 coordinates
# $link['S']: ---------- Link to Simbad database
# $link['E']: ---------- <NA>
# seq: ----------------- Sequence number
# $link[slen]: --------- Length of the series
# date: ---------------- Calendar date of observation
# mode: ---------------- Observation mode: High resolution or High efficiency
# fiber_b: ------------- Use of the second fiber (DARK, WAVE or SKY)
# exptime: ------------- exposure time
# sn26: ---------------- Signal/noise in order 26
# $link[view_spec]: ---- <NA>
# $link[view_head]: ---- <NA>
# $link[get_spec]: ----- <NA>
# $link[get_e2ds]: ----- <NA>
# $link[customize]: ---- <NA>
# $link[search_ccf]: --- <NA>
#-------------------- ---------------- --- --- --------------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ----------
#$link[objname]       $j2000           $li $li seq     $lin date            mode            fibe exptim sn2 $link[vie $link[vie $link[ge $link[ge $link[cus $link[sear
#                                      nk[ nk[         k[sl                                 r_b  e      6   w_spec]   w_head]   t_spec]  t_e2ds]  tomize]   ch_ccf]   
#                                      'S' 'E'         en]                                                                                                            
#                                      ]   ]                                                                                                                          
#-------------------- ---------------- --- --- ------- ---- --------------- --------------- ---- ------ --- --------- --------- -------- -------- --------- ----------
HD105422              J120809.7+552754 S   E   1093810    1 2011-01-17 HR SKY   271.0  61 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   1097220    1 2011-01-23 HR SKY   180.0  54 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   2114430    1 2017-03-15 HR SKY   180.0  49 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   2147710    1 2017-04-14 HR SKY   600.0  49 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   2530160    1 2018-06-25 HR SKY   500.0  58 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   2638140    1 2018-11-17 HR SKY   362.0  50 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   2680140    1 2019-02-13 HR SKY   337.0  50 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   2716040    1 2019-04-27 HR SKY  1500.0  50 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   2842070    1 2020-01-06 HR SKY   458.0  49 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   2989390    1 2020-12-22 HR SKY   600.0  48 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   2992710    1 2021-01-27 HR SKY   250.0  49 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   3010880    1 2021-03-24 HR SKY   500.0  49 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   3033260    1 2021-05-24 HR SKY   180.0  44 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   3142190    1 2021-12-12 HR SKY   300.0  49 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   3153080    1 2022-01-10 HR SKY  1524.0  50 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   3176730    1 2022-02-16 HR SKY   600.0  49 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   3201100    1 2022-04-10 HR SKY   400.0  38 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   3225310    1 2022-05-24 HR SKY  2050.0  40 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   3383370    1 2023-05-09 HR SKY   180.0  25 view_spec view_head get_spec get_e2ds customize search_CCF
HD105422              J120809.7+552754 S   E   3421970    1 2023-07-30 HR SKY   300.0  52 not public                                                 
HD105422              J120809.7+552754 S   E   3514420    1 2024-01-20 HR SKY   600.0  49 not public                                                 
#-- end of data table ----------------------------------------------------------
# 21 lines were successfully retrieved